<?php
/*
  $Id$

  osCommerce, Open Source E-Commerce Solutions
  http://www.oscommerce.com

  Copyright (c) 2010 osCommerce

  Released under the GNU General Public License
*/

  require('includes/application_top.php');

  if (!tep_session_is_registered('customer_id')) {
    $navigation->set_snapshot();
    tep_redirect(tep_href_link(FILENAME_LOGIN, '', 'SSL'));
  }

  require(DIR_WS_LANGUAGES . $language . '/' . FILENAME_ACCOUNT_HISTORY);

  $breadcrumb->add(NAVBAR_TITLE_1, tep_href_link(FILENAME_ACCOUNT, '', 'SSL'));
  $breadcrumb->add(NAVBAR_TITLE_2, tep_href_link(FILENAME_ACCOUNT_HISTORY, '', 'SSL'));

  require(DIR_WS_INCLUDES . 'template_top.php');
?>
<!--middle area start-->

<div class="middle-area">
  <div class="innermidbox fl">
    <div class="innermidbox-top"></div>
    <div class="innermidbox-mid">
      <div class="pdt5 pdl20 pdr20 pdb5 minheight527px">
        <div class="breadcrumbs"><a href="index.php">Home</a> > <span><?php echo HEADING_TITLE; ?></span></div>
        <div class="spacer10"></div>
        <div class="">
          <h1 class="pagetitle fl"><?php echo HEADING_TITLE; ?></h1>
          <a href="<?=tep_href_link(FILENAME_ACCOUNT, '', 'SSL')?>" class="backbtn fr"></a>
          <div class="clear"></div>
          <div class="hline"></div>
          <div class="spacer3"></div>
          <!--left panel start-->
          <?php include('includes/template_left.php'); ?>
          <!--left panel end-->
          <!--right panel start-->
          <div class="rightpanel mgl15 fl">
            <?php
  $orders_total = tep_count_customer_orders();

  if ($orders_total > 0) 
  {
    $history_query_raw = "select o.orders_id, o.date_purchased, o.delivery_name, o.billing_name, ot.text as order_total, s.orders_status_name from " . TABLE_ORDERS . " o, " . TABLE_ORDERS_TOTAL . " ot, " . TABLE_ORDERS_STATUS . " s where o.customers_id = '" . (int)$customer_id . "' and o.orders_id = ot.orders_id and ot.class = 'ot_total' and o.orders_status = s.orders_status_id and s.language_id = '" . (int)$languages_id . "' and s.public_flag = '1' order by orders_id DESC";
    $history_split = new splitPageResults($history_query_raw, MAX_DISPLAY_ORDER_HISTORY);
    $history_query = tep_db_query($history_split->sql_query);

    while ($history = tep_db_fetch_array($history_query)) 
	{
		$products_query = tep_db_query("select count(*) as count from " . TABLE_ORDERS_PRODUCTS . " where orders_id = '" . (int)$history['orders_id'] . "'");
      	$products = tep_db_fetch_array($products_query);

      	if(tep_not_null($history['delivery_name'])) 
		{
        	$order_type = TEXT_ORDER_SHIPPED_TO;
        	$order_name = $history['delivery_name'];
      	}
		else 
		{
        	$order_type = TEXT_ORDER_BILLED_TO;
        	$order_name = $history['billing_name'];
      	}
?>
            <h2 class="ordertitle">
              <?=TEXT_ORDER_NUMBER?>
              <?=$history['orders_id']?>
              <span style="font-size:16px;">(
              <?=$history['orders_status_name']?>
              )</span></h2>
            <div class="shoppingtable">
              <table width="100%" border="0" cellpadding="0" cellspacing="0">
                <tr>
                  <th width="24%" align="left" valign="middle"><?=TEXT_ORDER_DATE?></th>
                  <th width="12%" align="left" valign="middle"><?=TEXT_ORDER_PRODUCTS?></th>
                  <th width="31%" align="left" valign="middle"><?=$order_type?></th>
                  <th width="19%" align="left" valign="middle"><?=TEXT_ORDER_COST?></th>
                  <th width="14%">View</th>
                </tr>
                <tr>
                  <td><?=tep_date_long($history['date_purchased'])?></td>
                  <td><?=$products['count']?></td>
                  <td><?=tep_output_string_protected($order_name)?></td>
                  <td><strong>
                    <?=strip_tags($history['order_total'])?>
                    </strong></td>
                  <td><a href="<?=tep_href_link(FILENAME_ACCOUNT_HISTORY_INFO, (isset($HTTP_GET_VARS['page']) ? 'page=' . $HTTP_GET_VARS['page'] . '&' : '') . 'order_id=' . $history['orders_id'], 'SSL')?>" class="views-btn fl"></a></td>
                </tr>
              </table>
            </div>
            <div class="spacer15"></div>
            <?php
    }
?>
            <div class="clear"></div>
            <div class="spacer10"></div>
            <div class="pagingbox">
              <div class="pdl10 pdt5 pdb5 pdr10">
                <div class="fl"><?php echo $history_split->display_count(TEXT_DISPLAY_NUMBER_OF_ORDERS); ?></div>
                <div class="fr">
                  <div class="paging"><?php echo $history_split->display_links(MAX_DISPLAY_PAGE_LINKS, tep_get_all_get_params(array('page', 'info', 'x', 'y'))); ?> </div>
                </div>
                <div class="clear"></div>
              </div>
            </div>
            <?php
  }
  else 
  {
?>
            <div class="contentText">
              <p><?php echo TEXT_NO_PURCHASES; ?></p>
            </div>
            <?php
  }
?>
            <div class="spacer15"></div>
            <a href="<?=tep_href_link(FILENAME_ACCOUNT, '', 'SSL')?>" class="backbtn fl"></a>
            <div class="spacer15"></div>
          </div>
          <!--right panel end-->
          <div class="spacer10"></div>
        </div>
      </div>
    </div>
    <div class="innermidbox-bottom"></div>
  </div>
</div>
<!--middle area end-->
<div class="spacer25"></div>
</div>
<?php
  require(DIR_WS_INCLUDES . 'template_bottom.php');
  require(DIR_WS_INCLUDES . 'application_bottom.php');
?>
